<!-- Dettaglio del ticket-->
<div id="table">
    <blockquote>

        <H2>&raquo; Informazioni ticket</H2>

        <?php
        //Stampa di tutti i ticket presenti
        $utente = unserialize($_SESSION["user"]);

        $result = mysql_query("SELECT *
                               FROM ticket, stato, priorita, users, topic, assegnato
                               WHERE ticket.id_stato = stato.id and ticket.id_priorita = priorita.id and ticket.id_users=users.id");

        $row = mysql_fetch_array($result);
                $data = date("y-m-d",strtotime($row['data']));

        echo "<table width=500 border=1>";
        echo "<th colspan=4>Informazioni Ticket</th><tr>";
        echo "    <td>Nome</td><td>".$row['nome']."</td>";
        echo "    <td>Mail</td><td>".$row['mail']."</td>";
        echo "  </tr><tr>";
        echo "    <td>Cognome</td><td>".$row['cognome']."</td>";
        echo "    <td>User ID</td><td>".$row['id_users']."</td>";
        echo "  </tr><tr>";
        echo "    <td colspan=4>&nbsp;</td>";
        echo "  </tr><tr>";
        echo "    <td>No Ticket</td><td>".$row['id']."</td>";
        echo "    <td colspan=2>&nbsp;</td>";
        echo "  </tr><tr>";
        echo "    <td colspan=4>&nbsp;</td>";
        echo "  </tr><tr>";
        echo "    <td>Priorita</td>";
        echo "    <td>Stato</td>";
        echo "    <td>Assegnato</td>";
        echo "    <td>Topic</td>";
        echo "  </tr><tr>";
        echo "    <td>".$row['nome_priorita']."</td>";
        echo "    <td>".$row['nome_stato']."</td>";
        echo "    <td>".$row['id_user']."</td>";
        echo "    <td>".$row['nome_topic']."</td>";
        echo "  </tr><tr>";
        echo "    <td colspan=4>&nbsp;</td>";
        echo "  </tr><tr>";
        echo "    <td colspan=2>Descrizione</td>";
        echo "    <td>Data</td><td>".$data."</td>";
        echo "  </tr><tr>";
        echo "    <td colspan=4>".$row['descrizione']."</td>";
        echo "  </tr></table>";

        ?>

    </blockquote>
</div>